Tabela PhReturnToDel

Definicja tabeli PhReturnToDel

Name

PhReturnToDel

Code

PhReturnToDel

Comment

Zwroty do dostawców oraz reklamacje


Lista kolumn tabeli PhReturnToDel

Name

Code

ReturnToDelID

ReturnToDelID

ReturnNo

ReturnNo

ReturnToDelStatusID

ReturnToDelStatusID

ReturnToDelKindID

ReturnToDelKindID

ReturnDT

ReturnDT

Description

Description

Active

Active

DelivererID

DelivererID

TradeDocID

TradeDocID

BlockadeLots

BlockadeLots

CorrectingTradeDocID

CorrectingTradeDocID

StDocID

StDocID


Kolumna ReturnToDelID tabeli PhReturnToDel

Definicja kolumny ReturnToDelID tabeli PhReturnToDel

Name

ReturnToDelID

Code

ReturnToDelID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID zwrotu/reklamacji


Kolumna ReturnNo tabeli PhReturnToDel

Definicja kolumny ReturnNo tabeli PhReturnToDel

Name

ReturnNo

Code

ReturnNo

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

Numer zwrotu


Kolumna ReturnToDelStatusID tabeli PhReturnToDel

Definicja kolumny ReturnToDelStatusID tabeli PhReturnToDel

Name

ReturnToDelStatusID

Code

ReturnToDelStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID statusu zwrotu


Kolumna ReturnToDelKindID tabeli PhReturnToDel

Definicja kolumny ReturnToDelKindID tabeli PhReturnToDel

Name

ReturnToDelKindID

Code

ReturnToDelKindID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

ID rodzaju zwrotu


Kolumna ReturnDT tabeli PhReturnToDel

Definicja kolumny ReturnDT tabeli PhReturnToDel

Name

ReturnDT

Code

ReturnDT

Data Type

DATE

Mandatory

No

Comment

Data zwrotu


Kolumna Description tabeli PhReturnToDel

Definicja kolumny Description tabeli PhReturnToDel

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Opis zwrotu


Kolumna Active tabeli PhReturnToDel

Definicja kolumny Active tabeli PhReturnToDel

Name

Active

Code

Active

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Aktywny/usuniety zwrot


Kolumna DelivererID tabeli PhReturnToDel

Definicja kolumny DelivererID tabeli PhReturnToDel

Name

DelivererID

Code

DelivererID

Data Type

NUMBER(10)

Mandatory

No

Comment

Dostawca do którego wystawiono zwrot


Kolumna TradeDocID tabeli PhReturnToDel

Definicja kolumny TradeDocID tabeli PhReturnToDel

Name

TradeDocID

Code

TradeDocID

Data Type

NUMBER(10)

Mandatory

No

Comment

Faktura której dotyczy zwrot


Kolumna BlockadeLots tabeli PhReturnToDel

Definicja kolumny BlockadeLots tabeli PhReturnToDel

Name

BlockadeLots

Code

BlockadeLots

Data Type

NUMBER(3)

Mandatory

Yes

Comment

Blocade Lots after accepting ReturnToDel


Kolumna CorrectingTradeDocID tabeli PhReturnToDel

Definicja kolumny CorrectingTradeDocID tabeli PhReturnToDel

Name

CorrectingTradeDocID

Code

CorrectingTradeDocID

Data Type

NUMBER(10)

Mandatory

No

Comment

Trade doc correcting return


Kolumna StDocID tabeli PhReturnToDel

Definicja kolumny StDocID tabeli PhReturnToDel

Name

StDocID

Code

StDocID

Data Type

NUMBER(10)

Mandatory

No

Comment

Stock document


Lista kluczy tabeli PhReturnToDel

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PhReturnToDel

Definicja klucza Identifier_1 tabeli PhReturnToDel

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment